insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('Can Polyester and Wool fibres be blended?', 1, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What do you understand by Broderie Anglaise?', 1, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What has always been present in knitwear and can be matt, lustrous or supersoft.?', 1, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('Originally a very lightweight, sheer plain weave fabric made from silk. What is it?', 1, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What is the trade name of the yarn that contains Chitosan?', 1, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('The resulting yarn is from Combed cotton is much smoother and more even than one made from uncombed cotton?', 2, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('A polyester fibre with a special shape, which can draw moisture away from the wearers skin?', 2, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('100% Organic Cotton is grown in an environmentally friendly way without the use of insecticides or pesticides?', 2, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('A fibre having a cotton content higher than 50% is called?', 2, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('A cotton with extra stretch polyester or extra stretch nylon is called?', 2, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What is included in Denim to make it stretch denim?', 3, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('Elastane is also called as Lycra?', 3, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this Wash care symbol indicate?', 3, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this wash care symbol indicate?', 3, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this wash care symbol indicate?', 3, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this wash care symbol indicate?', 4, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this wash care symbol indicate?', 4, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this wash care symbol indicate?', 4, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('If bleach is not mentioned by a symbol, any bleach may be used on the garments?', 4, 1, 2, 'system', getdate());
insert into [dbo].[question_type] (Question_Statement, Category_TypeID, Level_TypeID, Status, CreatedBy, CreatedOn) values ('What does this wash care symbol mean?', 4, 1, 2, 'system', getdate());


/** Answer Options**/
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (1, 'True', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (1, 'False', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (2, 'A fancy yarn in which two or more yarns have been twisted together', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (2, 'A fabric embroidered on a machine, usually made from fine yarns', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (2, 'The fibre with hair of the Angora rabbit and is farmed in China', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (3, 'Cashmere', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (3, 'Canvas', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (3, 'Chenille', 1, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (4, 'Cotton', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (4, 'Wool', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (4, 'Chiffon', 1, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (5, 'Chitopoly', 1, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (6, 'True', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (6, 'False', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (7, 'Coolmax', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (7, 'Confort', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (7, 'Crepe', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (8, 'True', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (8, 'False', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (9, 'Combed Cotton', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (9, 'Cotton', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (9, 'Cotton rich
', 1, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (10, 'Combed cotton', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (10, 'Cotton rich', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (10, 'Cotton with stretch', 1, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (11, 'Elastane', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (11, 'Weaving', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (11, 'Embossing', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (12, 'True', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (12, 'False', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (13, 'Bleach when needed', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (13, 'Weaving', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (13, 'Embossing', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (14, 'Do not bleach', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (14, 'Weaving', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (14, 'Embossing', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (15, 'Tumble Dry, Normal', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (15, 'Weaving', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (15, 'Embossing', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (16, 'Tumble Dry, Normal', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (16, 'Dry clean
', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (16, 'Embossing', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (17, 'Tumble Dry, Normal', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (17, 'Weaving', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (17, 'Dry clean, any solvent', 1, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (18, 'Tumble Dry, Normal', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (18, 'Do not dry clean', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (18, 'Embossing', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (19, 'True', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (19, 'False', 0, 2, 'system', getDate());

insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (20, 'Do not Dry', 1, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (20, 'Weaving', 0, 2, 'system', getDate());
insert into [dbo].[answer_type] (question_typeID, answer_value, is_correct, status, createdBy, createdOn) values (20, 'Embossing', 0, 2, 'system', getDate());

/** Exam Type**/
insert into [dbo].[exam_type] (name, description, time, passing_marks, status, createdBy, createdOn) values ('Sales Advisor', 'Sales Advisor', 900, 2, 2, 'system', getDate());
insert into [dbo].[exam_type] (name, description, time, passing_marks, status, createdBy, createdOn) values ('Supervisor', 'Supervisor', 900, 2, 2, 'system', getDate());

/** Exam Category Level Mapping **/
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (1, 1, 1, 1);
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (1, 2, 1, 1);
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (1, 3, 1, 1);
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (1, 4, 1, 1);

insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (2, 1, 1, 1);
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (2, 2, 1, 2);
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (2, 3, 1, 1);
insert into [dbo].[Exam_Category_Level_Mapping] (Exam_TypeID, Category_TypeID, Level_TypeID, Number_Questions) values (2, 4, 1, 1);